<?php

class Application_Model_DbTable_inventoryItem extends Zend_Db_Table_Abstract
{
	protected $_name = 'tbl_inventoryItem';
	
	public function getInventoryItem($inventoryItem) {
		$result = $this->getAdapter()->fetchRow('SELECT inventoryItemDesc, eanCode, divisionDesc FROM bis.tbl_inventoryItem WHERE inventoryItem=\''.$inventoryItem.'\'');
		
		if(empty($result)) {
			$result = array('inventoryItemDesc' => 'not found!', 
							'divisionDesc' => '',
							'eanCode' => '');
		}
	
		return $result;
	}
	
	
}
